Tabela OncologyInitial

Definicja tabeli OncologyInitial

Name

OncologyInitial

Code

OncologyInitial

Comment

Tabela do zapisu diagnostyki wstepnej


Lista kolumn tabeli OncologyInitial

Name

Code

OncologyInitialID

OncologyInitialID

OncologicCardID

OncologicCardID

OtherPerfTestDescrID

OtherPerfTestDescrID

TumourICDID

TumourICDID

DiagnosisResultID

DiagnosisResultID

FurtherProceedingID

FurtherProceedingID

DiagnosisDoctorID

DiagnosisDoctorID

IssuingOrgUnitID

IssuingOrgUnitID

HistopatologyICDID

HistopatologyICDID

WaitingListItemStartDT

WaitingListItemStartDT

FirstAdviceDT

FirstAdviceDT

MalignantTumourCardNo

MalignantTumourCardNo

DiagnosisAdviceDT

DiagnosisAdviceDT

KZNZCancerNotificationDT

KZNZCancerNotificationDT

FurtherDeepDiagnosticDescr

FurtherDeepDiagnosticDescr

HistopatologyDescrID

HistopatologyDescrID

FurtherProceedingSpecialityID

FurtherProceedingSpecialityID


Kolumna OncologyInitialID tabeli OncologyInitial

Definicja kolumny OncologyInitialID tabeli OncologyInitial

Name

OncologyInitialID

Code

OncologyInitialID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna OncologicCardID tabeli OncologyInitial

Definicja kolumny OncologicCardID tabeli OncologyInitial

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna OtherPerfTestDescrID tabeli OncologyInitial

Definicja kolumny OtherPerfTestDescrID tabeli OncologyInitial

Name

OtherPerfTestDescrID

Code

OtherPerfTestDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

opis innych wykonanych badan


Kolumna TumourICDID tabeli OncologyInitial

Definicja kolumny TumourICDID tabeli OncologyInitial

Name

TumourICDID

Code

TumourICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

ICDID nowotworu


Kolumna DiagnosisResultID tabeli OncologyInitial

Definicja kolumny DiagnosisResultID tabeli OncologyInitial

Name

DiagnosisResultID

Code

DiagnosisResultID

Data Type

NUMBER(10)

Mandatory

No

Comment

wynik diagnozy (ze slownika)


Kolumna FurtherProceedingID tabeli OncologyInitial

Definicja kolumny FurtherProceedingID tabeli OncologyInitial

Name

FurtherProceedingID

Code

FurtherProceedingID

Data Type

NUMBER(10)

Mandatory

No

Comment

dalsze postepowanie (ze slownika)


Kolumna DiagnosisDoctorID tabeli OncologyInitial

Definicja kolumny DiagnosisDoctorID tabeli OncologyInitial

Name

DiagnosisDoctorID

Code

DiagnosisDoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

lekarz stawiajacy rozpoznanie


Kolumna IssuingOrgUnitID tabeli OncologyInitial

Definicja kolumny IssuingOrgUnitID tabeli OncologyInitial

Name

IssuingOrgUnitID

Code

IssuingOrgUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

swiadczeniodawaca


Kolumna HistopatologyICDID tabeli OncologyInitial

Definicja kolumny HistopatologyICDID tabeli OncologyInitial

Name

HistopatologyICDID

Code

HistopatologyICDID

Data Type

NUMBER(10)

Mandatory

No

Comment

rozpoznanie histopatologiczne


Kolumna WaitingListItemStartDT tabeli OncologyInitial

Definicja kolumny WaitingListItemStartDT tabeli OncologyInitial

Name

WaitingListItemStartDT

Code

WaitingListItemStartDT

Data Type

DATE

Mandatory

No

Comment

data wpisu na kolejke oczekujacych


Kolumna FirstAdviceDT tabeli OncologyInitial

Definicja kolumny FirstAdviceDT tabeli OncologyInitial

Name

FirstAdviceDT

Code

FirstAdviceDT

Data Type

DATE

Mandatory

No

Comment

data pierwszej porady zwiazanej z diagnostyka wstepna


Kolumna MalignantTumourCardNo tabeli OncologyInitial

Definicja kolumny MalignantTumourCardNo tabeli OncologyInitial

Name

MalignantTumourCardNo

Code

MalignantTumourCardNo

Data Type

VARCHAR2(20)

Mandatory

No

Comment

numer karty KZNZ


Kolumna DiagnosisAdviceDT tabeli OncologyInitial

Definicja kolumny DiagnosisAdviceDT tabeli OncologyInitial

Name

DiagnosisAdviceDT

Code

DiagnosisAdviceDT

Data Type

DATE

Mandatory

No

Comment

data porady zakonczonej rozpoznaniem


Kolumna KZNZCancerNotificationDT tabeli OncologyInitial

Definicja kolumny KZNZCancerNotificationDT tabeli OncologyInitial

Name

KZNZCancerNotificationDT

Code

KZNZCancerNotificationDT

Data Type

DATE

Mandatory

No

Comment

data zgloszenia nowotworu do KZNZ


Kolumna FurtherDeepDiagnosticDescr tabeli OncologyInitial

Definicja kolumny FurtherDeepDiagnosticDescr tabeli OncologyInitial

Name

FurtherDeepDiagnosticDescr

Code

FurtherDeepDiagnosticDescr

Data Type

VARCHAR2(200)

Mandatory

No

Comment

pole opisowe dla wybranej opcji: 'Diagnostyka poglebiona u lekarza innej specjcalizacji' w sekcji 'Dalsze postepowanie'


Kolumna HistopatologyDescrID tabeli OncologyInitial

Definicja kolumny HistopatologyDescrID tabeli OncologyInitial

Name

HistopatologyDescrID

Code

HistopatologyDescrID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna bedzie przechowyac dana opisowa rozpoznania histopatologicznego
(zastapi pole HistopatologyICDID)


Kolumna FurtherProceedingSpecialityID tabeli OncologyInitial

Definicja kolumny FurtherProceedingSpecialityID tabeli OncologyInitial

Name

FurtherProceedingSpecialityID

Code

FurtherProceedingSpecialityID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna odpowiada za specjalizacje 'orgUnita' nastepnego etapu realizowanego w ramach karty onkologicznej.


Lista kluczy tabeli OncologyInitial

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyInitial

Definicja klucza Identifier_1 tabeli OncologyInitial

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment